<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="zh-cn" xml:lang="zh-cn">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="恢复OceanBase数据库的单个或多个表">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="oceanbase_00041.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="">
<meta name="DC.Publisher" content="20250306">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="oceanbase_00244">
<meta name="DC.Language" content="zh-cn">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>恢复OceanBase数据库的单个或多个表</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="oceanbase_00244"></a><a name="oceanbase_00244"></a>

<h1 class="topictitle1">恢复OceanBase数据库的单个或多个表</h1>
<div><p>当需要恢复OceanBase数据库中的单个表或多个表时，请参考本节恢复数据库中的表至新位置。</p>
<div class="section"><h4 class="sectiontitle">前提条件</h4><ul><li>仅支持以集群的全量备份副本和增量备份副本进行表级恢复。</li><li>恢复前请确保恢复目标位置的数据目录剩余空间大于恢复副本缩减前大小，否则恢复将失败。</li><li>首次恢复时需要确保OceanBase数据库<strong id="oceanbase_00244__oceanbase_00044_b46493303116">restore_concurrency</strong>参数取值不为0，推荐取值10。</li><li>请确保在OceanBase数据库上已存在至少一个并且CPU、内存大于等于原租户的空闲资源池，若不存在则需要创建资源池，创建资源池具体操作请参考<a href="https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000355617" target="_blank" rel="noopener noreferrer">OceanBase官方文档</a>。</li></ul>
</div>
<div class="section"><h4 class="sectiontitle">操作步骤</h4><ol><li><span>选择<span class="uicontrol" id="oceanbase_00244__oceanbase_00044_zh-cn_topic_0000002199964685_uicontrol4958517162719">“<span id="oceanbase_00244__oceanbase_00044_zh-cn_topic_0000002199964685_text695841713270">数据利用</span> &gt; <span id="oceanbase_00244__oceanbase_00044_zh-cn_topic_0000002199964685_text1595819176270">副本数据</span> &gt; <span id="oceanbase_00244__oceanbase_00044_zh-cn_topic_0000002199964685_text14787949194912">数据库</span> &gt; OceanBase”</span>。</span></li><li><span>您可以以OceanBase资源维度或以副本维度查找副本：</span><p><ul><li>在<span class="uicontrol">“<span>资源</span>”</span>页签，根据名称查找到已注册到<span>OceanProtect</span>的集群，并单击名称。</li><li>在<span class="uicontrol">“<span>副本</span>”</span>页签，根据副本信息查找到要进行恢复的副本，在副本所在行单击<span class="menucascade">“<span class="uicontrol">更多 &gt; 表级恢复</span>”</span>。</li></ul>
<p>以下以数据库资源维度为例说明相关操作。</p>
</p></li><li><span>单击集群名称。</span></li><li><span>指定副本恢复</span><p><div class="note"><img src="public_sys-resources/note_3.0-zh-cn.png"><span class="notetitle"> </span><div class="notebody"><p id="oceanbase_00244__oceanbase_00044_oracle_gud_0083_p10749547154615">对于OceanProtect E6000备份一体机，使用复制副本执行恢复时，不支持在远端对该资源下的其他副本进行复制。</p>
</div></div>
<ol type="a"><li>依次选择年、月、天找到副本。<p>当时间上显示<span><img src="zh-cn_image_0000002200046225.png"></span>，即表示该月、该天存在副本。</p>
</li><li>在副本数据页面单击<span><img src="zh-cn_image_0000002164645456.png"></span>，单击需要恢复的全量备份副本或增量备份副本所在行的<span class="menucascade">“<span class="uicontrol">更多 &gt; 表级恢复</span>”</span>。</li></ol>
</p></li><li><span>在“表级恢复”界面左侧，先选择<span class="menucascade">“<span class="uicontrol">租户</span>”</span>，再选择需要恢复的单个或多个表（支持按完整准确名称搜索表）。</span></li><li><span>在“表级恢复”界面右侧，先选择<span class="menucascade">“<span class="uicontrol">恢复目标位置</span>”</span>，再填入<span class="menucascade">“<span class="uicontrol">新租户名</span>”</span>和选择<span class="menucascade">“<span class="uicontrol">资源池</span>”</span>。</span><p><p>相关参数说明如<a href="#oceanbase_00244__table558435323215">表1</a>所示。</p>

<div class="tablenoborder"><a name="oceanbase_00244__table558435323215"></a><a name="table558435323215"></a><table cellpadding="4" cellspacing="0" summary="" id="oceanbase_00244__table558435323215" frame="border" border="1" rules="all"><caption><b>表1 </b>表级恢复参数</caption><colgroup><col style="width:22.48%"><col style="width:77.52%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="22.48%" id="mcps1.3.3.2.6.2.2.2.3.1.1"><p>参数</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="77.52%" id="mcps1.3.3.2.6.2.2.2.3.1.2"><p>说明</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="22.48%" headers="mcps1.3.3.2.6.2.2.2.3.1.1 "><p>租户</p>
</td>
<td class="cellrowborder" valign="top" width="77.52%" headers="mcps1.3.3.2.6.2.2.2.3.1.2 "><p>选择一个原集群的租户。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="22.48%" headers="mcps1.3.3.2.6.2.2.2.3.1.1 "><p>恢复目标位置</p>
</td>
<td class="cellrowborder" valign="top" width="77.52%" headers="mcps1.3.3.2.6.2.2.2.3.1.2 "><p>指定恢复的目标OceanBase集群。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="22.48%" headers="mcps1.3.3.2.6.2.2.2.3.1.1 "><p>新租户名</p>
</td>
<td class="cellrowborder" valign="top" width="77.52%" headers="mcps1.3.3.2.6.2.2.2.3.1.2 "><p>填入一个恢复目标集群不存在的租户名。</p>
<div class="note"><span class="notetitle"> 说明： </span><div class="notebody"><p>租户名只能包含大小写英文字母、数字和下划线，而且必须以字母或下划线开头，租户名不能是 OceanBase 数据库的关键字。OceanBase 数据库中所支持的关键字请参见OceanBase官网。</p>
</div></div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="22.48%" headers="mcps1.3.3.2.6.2.2.2.3.1.1 "><p>资源池</p>
</td>
<td class="cellrowborder" valign="top" width="77.52%" headers="mcps1.3.3.2.6.2.2.2.3.1.2 "><p>选择一个目标集群的资源池。</p>
</td>
</tr>
</tbody>
</table>
</div>
</p></li><li><span>单击<span class="uicontrol">“确定”</span>。</span></li></ol>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>父主题：</strong> <a href="oceanbase_00041.html">恢复</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">版权所有 &copy; 华为技术有限公司</div></body>
</html>